AccessDiff Help
What is Compared?
Using AccessDiff > What is Compared?

The table below describes the comparisons performed for each type of object in the order that AccessDiff processes them.

Feature Description
Compare Forms All visual elements of the form are compared. The code module if any is compared. By default, AccessDiff automatically ignores any white space differences.
Compare Reports All visual elements of the report are compared. The code module if any is compared. By default, AccessDiff automatically ignores any white space differences.
Compare Macros All properties and commands of the macro are compared.
Compare Modules The full text of the module is compared. By default, AccessDiff automatically ignores any white space differences.
Compare References Detects broken references. Detects version differences. Detects missing references between the source and destination databases.
Compare Data Access Pages All elements are compared.
Compare Table Relationships All relationships between tables are compared. All properties of the relationships are compared.
Compare Table/Field Definitions Compares the existence or non-existence of tables between the source and destination databases and all field definitions.Detects column property differences. Detects table index differences.
Compare Queries The SQL between the source and destination databases are compared. By default, AccessDiff automatically ignores any white space differences.
Compare Records Detects all record differences based on the primary key.  If there is no primary key defined, there will be a prompt to enter the natural key.
Stored Procedures Compares SQL Server Stored Procedures for ADP (Access Database Projects)
Functions Compares SQL Server Functions for ADP (Access Database Projects)
Views Compares SQL Server Views for ADP (Access Database Projects)